class CreateAdInfos < ActiveRecord::Migration[6.1]
  def change
    create_table :ad_infos do |t|
      t.string :eventkey
      t.string :media_tag
      t.string :media_tag1
      t.string :media_name
      t.string :ad_user_name
      t.string :ad_plan
      t.string :ad_unit
      t.string :ad_source_url
      t.string :ad_source_name
      t.string :key_word
      t.string :ad_agent
      t.string :city_lv
      t.string :city_name
      t.string :activity_name
      t.string :product
      t.string :register_type
      t.string :customer_lv
      t.string :customer_type
      t.string :landing_page_name
      t.string :landing_page_url
      t.string :remark
      t.integer :cost
      t.integer :resgister_num
      t.integer :register_cost
      t.integer :add_teacher_num
      t.integer :add_teacher_cost
      t.integer :conversion_num
      t.integer :gmv

      t.timestamps
    end
  end
end
